const { exec } = require("../db/mysql")
const { genPassword } = require('../utils/cryp')




const login = (username,password) =>{
    
console.log(genPassword('19990612'))

    username = escape(username)
    
  password = genPassword(password)
    password = escape(password)

    const sql = `select username , realname from users where username = '${username}' and password = '${password}'`

    return exec(sql).then(rows =>{

return rows[0] || {}

    })
}

module.exports = {
    login
}